MS Access File

You can import metadata from MS Access files into an MS Access environment.

To import metadata from MS Access files, follow these steps:

  1. On the Explore tab, click an MS Access environment tile to view its details.
    Alternatively, in the Data Catalog pane, select the MS Access option to view all MS Access environments.
  2. Click Options.
    The available environment options appear.
  3. Click Scan Metadata.

    4. The MS Access Metadata Scan - Step1 page appears.

  4. Drag and drop or use to browse and select the MS Access file.
  5. Use the following scan options:
    Add New
    Use this option to insert new metadata into the environment.
    Update Existing + Add New
    Use this option to update the existing metadata based on tables and columns in the MS Access file.
    Update Existing + Add New + Invalidate
    Use this option to update the existing metadata without deleting it.
    Delete & Reload
    Use this option to delete all the business properties and data dictionary stored as metadata for this environment.
    Import Comments
    Use this option to import comments from MS Access tables and columns into the environment.
    Skip Empty Cells
    Use this option to skip blank cells in the MS Access file from overwriting existing values. This option is available only when you select the Update Existing + Add New or Update Existing + Add New + Invalidate option.
  6. Click .

    7. The MS Access Metadata Scan - Step2 page appears.

  7. Select the required tables.
  8. Click .

    9. The metadata is imported and saved in the environment.